FaExportImportFile

EntityType | Independent
Logical Entity Name | FaExportImportFile
Default Table Name | FaBatchExpImp
Logical Only | NO
Owner | dbo
Definition |
Note |

FaExportImportFile Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
Id |  | INTEGER | NO |
BatchIdentifier |  | VARCHAR(30) | YES |
SchoolIdentifier |  | CHAR(6) | YES |
Branch |  | CHAR(2) | YES |
FileCategory |  | CHAR(10) | YES |
FileType |  | CHAR(2) | YES |
NumberTimesRegenerated |  | INTEGER | YES |
LastRegeneratedDate |  | DATETIME | YES |
RegenertedBatchIdentifier |  | CHAR(26) | YES |
BatchTotalDollars |  | MONEY(19, 4) | YES |
BatchTotalDollarsAccepted |  | MONEY(19, 4) | YES |
SSCRTimeStamp |  | CHAR(20) | YES |
SSCRStatus |  | CHAR(1) | YES |
AwardYear |  | CHAR(7) | YES |
ExportDate |  | DATETIME | YES |
FileNameExported |  | VARCHAR(260) | YES |
BatchRecords |  | INTEGER | YES |
FileNameImported |  | VARCHAR(260) | YES |
IsImported |  | BIT | NO |
ImportDate |  | DATETIME | YES |
RecordsAccepted |  | INTEGER | YES |
RecordsRejected |  | INTEGER | YES |
RecordsPending |  | INTEGER | YES |
RecordsNOF |  | INTEGER | YES |
IsBatchRejected |  | BIT | NO |
RejectMessage |  | VARCHAR(49) | YES |
ImportUserID |  | INTEGER | YES |
ClearingHouseTerm |  | CHAR(15) | YES |
ClearingHouseCertificationDate |  | DATETIME | YES |
ClearingHouseFulllTimeRecs |  | INTEGER | NO |
ClearingHouseHalfTimeRecs |  | INTEGER | NO |
ClearingHouseLessThanHalfTimeRecs |  | INTEGER | NO |
ClearingHouseWithdrawalRecs |  | INTEGER | NO |
ClearingHouseGraduateRecs |  | INTEGER | NO |
ClearingHouseLoaRecs |  | INTEGER | NO |
ClearingHouseNoshowRecs |  | INTEGER | NO |
ClearingHouseDeceasedRecs |  | INTEGER | NO |
ProcessedDate |  | DATETIME | YES |
LastModifiedUserId |  | INTEGER | NO |
CreatedDateTime |  | DATETIME | NO |
LastModifiedDateTime |  | DATETIME | NO |
RowVersion |  | TIMESTAMP/DATE | NO |
FaRecipientID |  | INTEGER | YES |
SourceName |  | CHAR(32) | YES |
RecordsDuplicated |  | INTEGER | YES |
ReceiptDate |  | DATETIME | YES |
DocumentStatus |  | CHAR(1) | YES |
DocumentType |  | CHAR(2) | YES |
CampusId |  | INTEGER | YES |
ExportFilePath |  | VARCHAR(max) | YES |
SyServiceProcessExportMasterId |  | INTEGER | YES |
SyServiceProcessImportMasterID |  | INTEGER | YES |

FaExportImportFile Keys

Key Name | Key Type | Keys
FaBatchExpImp_SyServiceProcessImportMasterId_FaBatchExpImpId_U_N_IDX | Alternate Key | SyServiceProcessImportMasterID, Id
Nk_FaBatchExpImp_SyServiceProcessExportMasterId | Inversion Entry | SyServiceProcessExportMasterId
FaBatchExpImp_BatchID_N_N_IDX | Inversion Entry | BatchIdentifier
FaBatchExpImp_FileNameImported_N_N_IDX | Inversion Entry | FileNameImported
FaBatchExpImp_FaBatchExpImpID_U_C_IDX | PrimaryKey | Id
FaBatchExpImp_SSCRTimeStamp_FaBatchExpImpID_U_N_IDX | Alternate Key | SSCRTimeStamp, Id
FaBatchExpImp_SyCampusID_N_N_IDX | Inversion Entry | CampusId

FaExportImportFile Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
Campus | Non-Identifying | Zero or One to Zero or More |  |  |  | CampusId | NO
SyServiceProcessExportMaster | Non-Identifying | Zero or One to Zero or More |  |  |  | SyServiceProcessExportMasterId | NO
SyServiceProcessImportMaster | Non-Identifying | Zero or One to Zero or More |  |  |  | SyServiceProcessImportMasterID | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype
GainfulEmploymentExportImportFile | Non-Identifying | One To Zero or More |  |  |  |  | NO
GainfulEmploymentExportImportFile | Non-Identifying | One To Zero or More |  |  |  |  | NO
Isir | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaCHExportBatchProgVerList | Non-Identifying | One To Zero or More |  |  |  |  | NO
CodSummaryInformation | Non-Identifying | One To Zero or More |  |  |  |  | NO
CommonlineResponse | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaLoanCommonLineChangeSendLog | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaPellSASAwardDetail | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaPellSASCashDetail | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaPellSASCashSummary | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaPellSASDisbursementDetail | Non-Identifying | One To Zero or More |  |  |  |  | NO
ScheduledDisbursement | Non-Identifying | One To Zero or More |  |  |  |  | NO
FaSscr001 | Non-Identifying | One To Zero or More |  |  |  |  | NO
TeachSchoolAccountStatementAwardDetail | Non-Identifying | One To Zero or More |  |  |  |  | NO
TeachSchoolAccountStatementCashTransaction | Non-Identifying | One To Zero or More |  |  |  |  | NO
TeachSchoolAccountStatementCashBalance | Non-Identifying | One To Zero or More |  |  |  |  | NO
ProcessReportData | Non-Identifying | One To Zero or More |  |  |  |  | NO
SyBatchRegulatory | Non-Identifying | One To Zero or More |  |  |  |  | NO

FaExportImportFile Check Constraints

Check Constraint Name | CheckConstraint

FaExportImportFile Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.FaExportImportFile | NO |  |  |
Physical (Microsoft SQL Server) dbo.FaBatchExpImp | NO |  |  |

FaExportImportFile Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Academic Records
Physical (Microsoft SQL Server) | Financial Aid

FaExportImportFile Data Movement Rules

Name | Type | Rule Text/Value